insert overwrite table yl_ods.tab_barscan_noparsepackage partition(dt)
select
recordid
,billcode
,scantime
,inputtime
,scanuser
,inputsite
,scantype
,nextstation
,projectflag
,processflag
,weight
,remark
,null as mobile
,pistolid
,remark1
,remark2
,null as destination
,shifts
,sendsite
,scansitecode
,uploadtime
,remark3
,scanusercode
,send_deliver_usercode
,nextstationcode
,source
,remark4
,remark5
,remark6
,scansiteid
,nextstationid
,scanuserid
,send_deliver_userid
,transfercode
,expresstype
,dt
from jms_ods.tab_barscan_noparsepackage
where dt = '{{ execution_date | cst_ds }}' ;
